SELECT formmain_0241.ID,onetest.*
FROM
onetest 
LEFT JOIN formmain_0241 ON onetest.UdstrCd = formmain_0241.field0001
WHERE
onetest.UdstrDescCn <> formmain_0241.field0002 OR
onetest.UdstrDescEn <> formmain_0241.field0011 OR
onetest.Email <> formmain_0241.field0012 OR
onetest.Address <> formmain_0241.field0010 OR
onetest.ZipCd <> formmain_0241.field0004 OR
onetest.PhoneNo <> formmain_0241.field0013 OR
onetest.Udstr_Remark1 <> formmain_0241.field0005 OR
onetest.Udstr_Remark2 <> formmain_0241.field0006 OR
onetest.FaxNo <> formmain_0241.field0007 OR
onetest.DD_DATE_D2 <> formmain_0241.field0008 OR
onetest.Udstr_Remark3 <> formmain_0241.field0015 OR
onetest.Udstr_Remark4 <> formmain_0241.field0016 OR
onetest.Director <> formmain_0241.field0017 OR
onetest.DirectorNo <> formmain_0241.field0018 OR
onetest.DirectorMobile <> formmain_0241.field0019 OR
onetest.DirectorEmail <> formmain_0241.field0020 OR
onetest.FinanceContact <> formmain_0241.field0021 OR
onetest.FinanceContactNo <> formmain_0241.field0022 OR
onetest.FinanceContactMobile <> formmain_0241.field0023 OR
onetest.FinanceEmail <> formmain_0241.field0024 OR
onetest.CompanyCd <> formmain_0241.field0025 OR
onetest.PaymentBy <> formmain_0241.field0026 OR
onetest.SimsCd <> formmain_0241.field0027 OR
onetest.UdstrTypeName <> formmain_0241.field0028 OR
onetest.CreditLvlName <> formmain_0241.field0029 OR
onetest.ProvinceName <> formmain_0241.field0030 OR
onetest.CityName <> formmain_0241.field0031 OR
onetest.CoopTypeName <> formmain_0241.field0032 OR
onetest.Dstr_CD <> formmain_0241.field0033 OR
onetest.Dstr_Desc_CN <> formmain_0241.field0034 OR
onetest.Dstr_Desc_EN <> formmain_0241.field0035 OR
onetest.Email1 <> formmain_0241.field0036 OR
onetest.Email2 <> formmain_0241.field0037 OR
onetest.Zip_CD <> formmain_0241.field0038 OR
onetest.Dstr_PhoneNo <> formmain_0241.field0039 OR
onetest.Dstr_FaxNo <> formmain_0241.field0040 OR
onetest.Dstr_Remark1 <> formmain_0241.field0041 OR
onetest.Dstr_Remark2 <> formmain_0241.field0042 OR
onetest.Dstr_Remark3 <> formmain_0241.field0043 OR
onetest.Dstr_Remark4 <> formmain_0241.field0044 OR
onetest.CoopStatus <> formmain_0241.field0045 OR
onetest.Dstr_Director <> formmain_0241.field0046 OR
onetest.Dstr_Director_NO <> formmain_0241.field0047 OR
onetest.Dstr_Director_Mobile <> formmain_0241.field0048 OR
onetest.Dstr_Finance_Contact <> formmain_0241.field0049 OR
onetest.Dstr_Finance_Contact_NO <> formmain_0241.field0050 OR
onetest.Dstr_Finance_Contact_Mobile <> formmain_0241.field0051 OR
onetest.Fd_Operator <> formmain_0241.field0052 OR
onetest.Fd_OperatorNO <> formmain_0241.field0053 OR
onetest.Upload_DT <> formmain_0241.field0054 OR
onetest.Franchise <> formmain_0241.field0055 OR
onetest.BU <> formmain_0241.field0056 OR
onetest.Dstr_Coop_Start_DT <> formmain_0241.field0057 OR
onetest.Dstr_Coop_End_DT <> formmain_0241.field0058 OR
onetest.Dstr_Coop_Status_CD <> formmain_0241.field0059 OR
onetest.Parent_Dstr_CD <> formmain_0241.field0060 OR
onetest.Parent_Dstr_Desc_CN <> formmain_0241.field0061 OR
onetest.Biz_Contact <> formmain_0241.field0062 OR
onetest.Biz_Contact_NO <> formmain_0241.field0063 OR
onetest.Biz_Contact_Mobile <> formmain_0241.field0064 OR
onetest.Company_CD <> formmain_0241.field0065 OR
onetest.CURRENCY_ID <> formmain_0241.field0066 OR
onetest.SAP_CD <> formmain_0241.field0067 OR
onetest.Payment_By <> formmain_0241.field0068 OR
onetest.DstrTypeName <> formmain_0241.field0069 OR
onetest.DstrCoopTypeName <> formmain_0241.field0070 OR
onetest.FdSoftwareName <> formmain_0241.field0071 OR
onetest.FdStatuseName <> formmain_0241.field0072 OR
onetest.DstrCoopStatusName <> formmain_0241.field0074 OR
onetest.DstrDstrLvlName <> formmain_0241.field0075 OR
onetest.DstrDstrClassName <> formmain_0241.field0076 OR
onetest.DstrCreditLvlName <> formmain_0241.field0077 OR
onetest.DstrProvinceName <> formmain_0241.field0078 OR
onetest.DstrCityName <> formmain_0241.field0079 OR
onetest.CurrencyName <> formmain_0241.field0080 OR
onetest.iChannel_Email <> formmain_0241.field0081 OR
onetest.iChannel_Mobile <> formmain_0241.field0082 OR
onetest.iChannel_Contact <> formmain_0241.field0083 OR
onetest.iChannel_Contact_No <> formmain_0241.field0084 OR
onetest.BusinessContact <> formmain_0241.field0085 OR
onetest.BusinessNo <> formmain_0241.field0086 OR
onetest.BusinessMobile <> formmain_0241.field0087 OR
onetest.BusinessEmail <> formmain_0241.field0088 OR
onetest.DataContact <> formmain_0241.field0089 OR
onetest.DataNo <> formmain_0241.field0090 OR
onetest.DataMobile <> formmain_0241.field0091 OR
onetest.DataEmail <> formmain_0241.field0092 OR
onetest.Contractor <> formmain_0241.field0093 OR
onetest.ContractorNo <> formmain_0241.field0094 OR
onetest.ContractorMobile <> formmain_0241.field0095 OR
onetest.ContractorEmail <> formmain_0241.field0096 OR
onetest.DD_Date <> formmain_0241.field0097 OR
onetest.DD_DATE_END <> formmain_0241.field0098 OR
onetest.DD_Status <> formmain_0241.field0099 OR
onetest.DD_DATE_END_D2 <> formmain_0241.field0100 OR
onetest.DD_STATUS_D2 <> formmain_0241.field0101 OR
onetest.DD_DATE_SERVICE <> formmain_0241.field0102 OR
onetest.DD_DATE_END_SERVICE <> formmain_0241.field0103 OR
onetest.DD_STATUS_SERVICE <> formmain_0241.field0104 OR
onetest.UPDATE_DT <> formmain_0241.field0105 OR
onetest.DSM_Email <> formmain_0241.field0106 OR
onetest.RSM_Email <> formmain_0241.field0107 OR
onetest.BU_DSM_Email <> formmain_0241.field0108 OR
onetest.BU_RSM_Email <> formmain_0241.field0109 